UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xE7oxalFVNv6mWzLOeSIY0nU27KYqTxzAsFGbzOcy+8='
WHERE
key_id = 'c4104d66dbd96e0c7493757c01c9cdfd7b77266ca17c2c230e2c5c17b7ffc845'
AND (
token = 'xE7oxalFVNv6mWzLOeSIY0nU27KYqTxzAsFGbzOcy+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)