UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hMnNVOidgfSDuNCh8jSl84esw2s5AqanCh0r2bGb7Jk='
WHERE
key_id = '4be22b319b58ea84e83f05820ae0ca1360bc51e3e716a21b973844c559beb64f'
AND (
token = 'hMnNVOidgfSDuNCh8jSl84esw2s5AqanCh0r2bGb7Jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)