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