UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5wt0tXdxDOVsfCr7go4Xc5JkSTy2dfNMBTHupX9w8bw='
WHERE
key_id = 'e356b6905a3c5377bd9d56ad15f76332811a9c4f5eb46aee87d473e43f6096ef'
AND (
token = '5wt0tXdxDOVsfCr7go4Xc5JkSTy2dfNMBTHupX9w8bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)