UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPR/5vS7yhTwieqNhbVwoXdPCHDZRYNhfq+ITXRnCUc='
WHERE
key_id = 'cfbe365c6e8403daeaf3da466897ab2ef35814a06b0780143e01a7711f4094fe'
AND (
token = 'BPR/5vS7yhTwieqNhbVwoXdPCHDZRYNhfq+ITXRnCUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)