UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w8hZuj8/hk67VZxWpGt8D2yol1tjE7VuxGUu3ycIZPM='
WHERE
key_id = '36a4c20883042b44365865a1626c71dc7100817f1e112a71e503063c2b3f70c5'
AND (
token = 'w8hZuj8/hk67VZxWpGt8D2yol1tjE7VuxGUu3ycIZPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)