UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O1z5qqOjqzaEdK9tt62FYpH87ncnzM3Pd1y8H178vTg='
WHERE
key_id = 'e86612b94834a59dc104915951adfe76c2427e8f69e58c28d9dcc674add7fe15'
AND (
token = 'O1z5qqOjqzaEdK9tt62FYpH87ncnzM3Pd1y8H178vTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)