UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KW7yTO5bcPIWXvFDcsZiBmbu3u6FBpwOt/8Ei9xHdoI=' 
WHERE 
  key_id = '6d2261b550bd483df7bca6e5bbeba8d7cf41879c37dd3dd297955b7dcd9871c7' 
  AND (
    token = 'KW7yTO5bcPIWXvFDcsZiBmbu3u6FBpwOt/8Ei9xHdoI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048