UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dNP8GPpbzXfjE0L/1D6NWjOu7mq7mhZtBeHYZov2HBs='
WHERE
key_id = 'db6a1623b1c5c45e802bab16f0fe1e713883a662ef57c11576bf4a184a95af87'
AND (
token = 'dNP8GPpbzXfjE0L/1D6NWjOu7mq7mhZtBeHYZov2HBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)