UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Z6Q5/+X8m/XDY779pAAsCVhoyqWJSZv/QtmnvRWKzl4=' 
WHERE 
  key_id = '2a839abf9037dd11a3a17124902b27e9d6cc2566c8d309a47f14e5d7f55730e0' 
  AND (
    token = 'Z6Q5/+X8m/XDY779pAAsCVhoyqWJSZv/QtmnvRWKzl4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045