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