UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEOCav5JWmKhMX8CRXCkoqfLlwTwgTSNp4UPGfR0rok='
WHERE
key_id = 'ea02acc784e9cfe82041b78057858c10e1a69792b171c33b83bca060b55ddbf1'
AND (
token = 'XEOCav5JWmKhMX8CRXCkoqfLlwTwgTSNp4UPGfR0rok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)