UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GcJ8hgGqSeZ6z/d6Y6x0Lq6rhZUmbwP7M4oyZpx3tR4='
WHERE
key_id = 'e3ee890d61275b45a42ec0eb07f92409c2c0d4cffcea2ee3fb86e55ea9ca6aa8'
AND (
token = 'GcJ8hgGqSeZ6z/d6Y6x0Lq6rhZUmbwP7M4oyZpx3tR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)