UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jCMAbt6oL8WSx7I0/UnLAwwD9VjaQHE4qzf7pgLKUHE=' 
WHERE 
  key_id = '8d03a4659c36db6c0bd13387e40012e5bb0a7e8cb6298a356c25ab5810788f85' 
  AND (
    token = 'jCMAbt6oL8WSx7I0/UnLAwwD9VjaQHE4qzf7pgLKUHE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021