UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ogtgPhrDwE0gsI/fudvp3W1DkmiUDIix3u3lrIkL1xM='
WHERE
key_id = 'def50af8c23c4fc6ab72cc77c664dfb0dce94e389eb0a7f7aa653d0a31e935cb'
AND (
token = 'ogtgPhrDwE0gsI/fudvp3W1DkmiUDIix3u3lrIkL1xM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)