UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8f0CnF3VPsalvZuFZCIh3MqPsbtqtn8K/Erg2Lj3a9M='
WHERE
key_id = 'b86dc7ffb6ddfcd5656849ac07eeb3fb8d3a23d7efb05f3246349a15c8969866'
AND (
token = '8f0CnF3VPsalvZuFZCIh3MqPsbtqtn8K/Erg2Lj3a9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)