UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZVDuxVCeL80RCIwl6ZAywTa5vQqMLuNsjd3qTokSSc='
WHERE
key_id = '723a520adf61666d025744effa789c8edbb7ecce0fda7cedb1b86673b63332bf'
AND (
token = 'lZVDuxVCeL80RCIwl6ZAywTa5vQqMLuNsjd3qTokSSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)