UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcBUK2iWpi/JbPOeh3+c1Rd/2UEgvASRo91/wbCARt8='
WHERE
key_id = '0bf26c9cc246e444b47743c5caf5d29e5cd109539a2c7ec1096f583e061bfddc'
AND (
token = 'XcBUK2iWpi/JbPOeh3+c1Rd/2UEgvASRo91/wbCARt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)