UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yeY7mi6vDU6RQtMgwUOTcKZC8mNJml7UalrjW+7EgLQ='
WHERE
key_id = 'c01975f37ec97a312b1840d749fb192c9f43f174546b948f3a9a9276380f36a4'
AND (
token = 'yeY7mi6vDU6RQtMgwUOTcKZC8mNJml7UalrjW+7EgLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)