UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'br/2Ja8Yket5ZGcaz6SDWtW5S0w9rlPDylox6Rf36Ew='
WHERE
key_id = 'a7caddeb9e2a384c55efdc8e47ee145b9fb78e1cdfe5283fa4a4f2cebb75990f'
AND (
token = 'br/2Ja8Yket5ZGcaz6SDWtW5S0w9rlPDylox6Rf36Ew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)