UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsXE6GtMUbsu8pOWhLgWWtXPPKbiW56akIKvXc8hghY='
WHERE
key_id = '1020676c62b54b0b3de66152505ab47b6a016a37b6f3093f6bc79491ea49635b'
AND (
token = 'QsXE6GtMUbsu8pOWhLgWWtXPPKbiW56akIKvXc8hghY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)