UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/bTGcYLqVWeT6xEr0RezLMcntA0smhPYva40hI9HBL0='
WHERE
key_id = '97700d56df7a4f534f05d113bf108c4eddc13f6bed95f88fe42fb9d475935731'
AND (
token = '/bTGcYLqVWeT6xEr0RezLMcntA0smhPYva40hI9HBL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)