UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'USgQc2zflmfNrnxjeJtHuUOVPhKZPu50XYe019yAGfk='
WHERE
key_id = '458b866633d028aa35d0e871dd37f2b5ffe5963f813c20ba4aa2e9692fffea2c'
AND (
token = 'USgQc2zflmfNrnxjeJtHuUOVPhKZPu50XYe019yAGfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)