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