UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpOJZNTEWg+v5LlCmMyPNNOCaKUqVZeEFFgnZiJpeaM='
WHERE
key_id = 'b91a8077e6576d64b6721ab08b0cb475169e6eea53649b732f665d75686a09bf'
AND (
token = 'ZpOJZNTEWg+v5LlCmMyPNNOCaKUqVZeEFFgnZiJpeaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)