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