UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zg4g4xlH8lG8LCJ+2sjbcet0R+kWa/+2TQuFJT4242Q='
WHERE
key_id = '1804486c5c71aa4cfaa92d0917a5b54636d3107725f5ad83b53a022d1b1603cf'
AND (
token = 'Zg4g4xlH8lG8LCJ+2sjbcet0R+kWa/+2TQuFJT4242Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)