UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfvqpdF37vvmzAcJ3EhCktpbCuHGJc7gYrAX8r6ucf8='
WHERE
key_id = '9d27a337284a430d113af154b8730e18efd45686c1ad0b442f37f87d09444bd3'
AND (
token = 'dfvqpdF37vvmzAcJ3EhCktpbCuHGJc7gYrAX8r6ucf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)