UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mPQGD5EN92vJbQTxS2I/MAeyF39V78wmN2efS9yx1B8='
WHERE
key_id = 'b7edc463f92c0bc6ff674ad1f17ac27b1f809f538645cdf83b1deaecff3a5063'
AND (
token = 'mPQGD5EN92vJbQTxS2I/MAeyF39V78wmN2efS9yx1B8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)