UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7BTRsvhgec/9eNt8I5/tQSMzEqiAD6/NpdAOkYmLNA='
WHERE
key_id = '7a53f741e2ec0b16ad84441ad6ca5cb7371990ed95a858845a2e5af61347a082'
AND (
token = 'p7BTRsvhgec/9eNt8I5/tQSMzEqiAD6/NpdAOkYmLNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)