UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iFvJUhlCqTJKAnq+JFoXWXhcbkNVP+tPPCsCrh5OaaU='
WHERE
key_id = '466ae49b7e6aae72077fe5456620012e275e11129713bb3535b85001b11c576f'
AND (
token = 'iFvJUhlCqTJKAnq+JFoXWXhcbkNVP+tPPCsCrh5OaaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)