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