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