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